package com.sxhuayuan.parking.dao;

import org.springframework.data.jpa.repository.Query;

import com.sxhuayuan.parking.entity.MonthCardOrder;

public interface MonthCardOrderDao extends BaseDao<MonthCardOrder, Long> {

	/** 根据系统订单号查询 */
	MonthCardOrder findBySn(String sn);

	/** 根据华贝的订单号查询 */
	@Query(value = "select * from hypk_month_card_order where trade_no = ?1", nativeQuery = true)
	MonthCardOrder findByTradeNo(String tradeNo);

}
